A Conserative Property of a Nested Relational Query Language
نویسنده
چکیده
We proposed in [7] a nested relational calculus and a nested relational algebra based on structural recursion [6,5] and on monads [27,16]. In this report, we describe relative set abstraction as our third nested relational query language. This query language is similar to the well known list comprehension mechanism in functional programming languages such as Haskell [ll], Miranda [24], KRC [23], etc. This language is equivalent to our earlier query languages both in terms of semantics and in terms of equational theories. This strong sense of equivalence allows our three query languages to be freely combined into a nested relational query language that is robust and user-friendly. Comments University of Pennsylvania Department of Computer and Information Science Technical Report No. MSCIS-92-59. This technical report is available at ScholarlyCommons: http://repository.upenn.edu/cis_reports/472 A Conservative Property Of A Nested Relational Query Language MS-CIS-92-59 LOGIC & COMPUTATION 48
منابع مشابه
The Dichotomous Intensional Expressive Power of the Nested Relational Calculus with Powerset
Most existing studies on the expressive power of query languages have focused on what queries can be expressed and what queries cannot be expressed in a query language. They do not tell us much about whether a query can be implemented efficiently in a query language. Yet, paradoxically, efficiency is of primary concern in computer science. In this paper, the efficiency of queries in NRC(powerse...
متن کاملQuery Languages for Bags and Aggregate Functions
Theoretical foundations for querying databases based on bags are studied in this paper. We fully determine the strength of many polynomial-time bag operators relative to an ambient query language. Then we obtain BQL, a query language for bags, by picking the strongest combination of these operators. The relationship between the nested relational algebra and various fragments of BQL is investiga...
متن کاملAggregate Functions, Conservative Extension, and Linear Orders
1 Summary Practical database query languages are usually equipped with some aggregate functions. For example, \\nd mean of column" can be expressed in SQL. However, the manner in which aggregate functions were introduced in these query languages leaves something to be desired. Breazu-Tannen, Buneman, and Wong 3] introduced a nested relational language NRC(=) based on monads 16, 24] and structur...
متن کاملQuery shredding: Efficient relational evaluation of queries over nested multisets (extended version)
Nested relational query languages have been explored extensively, and underlie industrial language-integrated query systems such as Microsoft’s LINQ. However, relational databases do not natively support nested collections in query results. This can lead to major performance problems: if programmers write queries that yield nested results, then such systems typically either fail or generate a l...
متن کاملAggregate Functions, Conservative Extensions, and Linear Orders
1 Summary Practical database query languages are usually equipped with some aggregate functions. For example, \\nd mean of column" can be expressed in SQL. However, the manner in which aggregate functions were introduced in these query languages leaves something to be desired. Breazu-Tannen, Buneman, and Wong 3] introduced a nested relational language NRC(=) based on monads 16, 24] and structur...
متن کامل